
/*
'===============================================================================
'  Generated From - DAAB_DAL_NET2.vbgen
'  It is based on the DAAB from the November 2005 Enterprise Library
'  
'  This object is 'abstract' which means you need to inherit from it to be able
'  to instantiate it.  This is very easily done. You can override properties and
'  methods in your derived class, this allows you to regenerate this class at any
'  time and not worry about overwriting custom code. 
'
'  Custom DAL methods should be written into the inherited class.
' 
'  Version: 1.0
'  Date:	30/01/06
'  Summary: SelectOne, SelectAll, SelectAllWForeignKey, Insert, Update, Delete,
'  			DeleteAllWForeignKey.
'===============================================================================
*/
using System;
using System.Data;
using System.Data.Common;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;


namespace PlacementManager.DAL
{
    public abstract class _vwGeo_LocationWithAdministrativeDivisionData_DAL
    {
		#region Members
		protected int _GeoLocationID;
		protected int _UniqueFeatureID;
		protected int _UniqueNameID;
		protected double _Latitude;
		protected double _Longitude;
		protected int _DMS_Latitude;
		protected int _DMS_Longitude;
		protected string _UniversalTransverseMercator;
		protected string _JointOperationsGraphic;
		protected string _FeatureClassification;
		protected string _FeatureDesignation;
		protected string _CountryCode;
		protected int _CountryID;
		protected string _AdministrativeDivision;
		protected int _AdministrativeDivisionID;
		protected string _ShortName;
		protected string _SortName;
		protected string _FullName;
		protected DateTime _DateCreated;
		protected string _DivisionName;
		protected string _DivisionPostalAbbreviation;
		#endregion

		#region Properties
		
		public int GeoLocationID
		{
			get	{ return _GeoLocationID; }
			set	{ _GeoLocationID = value; }
		}
		
		public int UniqueFeatureID
		{
			get	{ return _UniqueFeatureID; }
			set	{ _UniqueFeatureID = value; }
		}
		
		public int UniqueNameID
		{
			get	{ return _UniqueNameID; }
			set	{ _UniqueNameID = value; }
		}
		
		public double Latitude
		{
			get	{ return _Latitude; }
			set	{ _Latitude = value; }
		}
		
		public double Longitude
		{
			get	{ return _Longitude; }
			set	{ _Longitude = value; }
		}
		
		public int DMS_Latitude
		{
			get	{ return _DMS_Latitude; }
			set	{ _DMS_Latitude = value; }
		}
		
		public int DMS_Longitude
		{
			get	{ return _DMS_Longitude; }
			set	{ _DMS_Longitude = value; }
		}
		
		public string UniversalTransverseMercator
		{
			get	{ return _UniversalTransverseMercator; }
			set	{ _UniversalTransverseMercator = value; }
		}
		
		public string JointOperationsGraphic
		{
			get	{ return _JointOperationsGraphic; }
			set	{ _JointOperationsGraphic = value; }
		}
		
		public string FeatureClassification
		{
			get	{ return _FeatureClassification; }
			set	{ _FeatureClassification = value; }
		}
		
		public string FeatureDesignation
		{
			get	{ return _FeatureDesignation; }
			set	{ _FeatureDesignation = value; }
		}
		
		public string CountryCode
		{
			get	{ return _CountryCode; }
			set	{ _CountryCode = value; }
		}
		
		public int CountryID
		{
			get	{ return _CountryID; }
			set	{ _CountryID = value; }
		}
		
		public string AdministrativeDivision
		{
			get	{ return _AdministrativeDivision; }
			set	{ _AdministrativeDivision = value; }
		}
		
		public int AdministrativeDivisionID
		{
			get	{ return _AdministrativeDivisionID; }
			set	{ _AdministrativeDivisionID = value; }
		}
		
		public string ShortName
		{
			get	{ return _ShortName; }
			set	{ _ShortName = value; }
		}
		
		public string SortName
		{
			get	{ return _SortName; }
			set	{ _SortName = value; }
		}
		
		public string FullName
		{
			get	{ return _FullName; }
			set	{ _FullName = value; }
		}
		
		public DateTime DateCreated
		{
			get	{ return _DateCreated; }
			set	{ _DateCreated = value; }
		}
		
		public string DivisionName
		{
			get	{ return _DivisionName; }
			set	{ _DivisionName = value; }
		}
		
		public string DivisionPostalAbbreviation
		{
			get	{ return _DivisionPostalAbbreviation; }
			set	{ _DivisionPostalAbbreviation = value; }
		}
		
		#endregion

        //Constructor
        public _vwGeo_LocationWithAdministrativeDivisionData_DAL()
        {

        }
		
		/// <summary>
		/// Purpose: SelectAll method. This method will Select all rows from the table.
		/// </summary>
		/// <returns></returns>
		public DataSet SelectAll()
        {
            // Create the Database object, using the default database service. The
            // default database service is determined through configuration.
            Database db = DatabaseFactory.CreateDatabase("PlacementManager");

            string sqlCommand = "pr_vwGeo_LocationWithAdministrativeDivisionData_DAL_SelectAll";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            // Retrieve products from the specified category.
            db.AddInParameter(dbCommand, "ErrorCode", DbType.Int32, null);
		
            DataSet dsToReturn = null;
            dsToReturn = db.ExecuteDataSet(dbCommand);
            return dsToReturn;
        }
	}
}

